package com.example.demo.others.git;

import com.alibaba.fastjson.JSONObject;

import java.text.MessageFormat;
import java.util.HashMap;
import java.util.Map;

/**
 * Created by Administrator on 2017/3/17 0017.
 */

public class IosPrdSql {




    public static void main(String[] args) {
        JSONObject j = new JSONObject() ;
        Map map = new HashMap() ;
        j.getObject("",map.getClass());

        String s  ="prd-com.tzzs.lot.p12\n"
                 ;

        for (String s1 : s.split("\\n")) {
            String p = s1.replaceAll("prd-" , "").replaceAll(".p12" ,"");

            String pi = "insert into t_push_ios_config ( PUSH_APPCD" +
                    ",PUSH_PASSWORD" +
                    ",PUSH_ENVIRONMENT" +
                    ",PUSH_LOCALCACHE" +
                    ",PUSH_QUEUESIZE" +
                    ",PUSH_STATUS" +
                    ",PUSH_KEYSTORE" +
                    ",DEVICE_TYPE  ) values ( {0}" +
                    ",{1}" +
                    ",{2}" +
                    ",{3}" +
                    ",2" +
                    ",1" +
                    ",{4}" +
                    ",{5} )"  ;
            System.out.println(MessageFormat.format(pi , "'"+ p +"'",
                     "'111111111'",
                     "'Product'",
                     "'false'",

                    "'config/"+ s1 +"'",
                    "'ios'" )
            +";" );


        }
    }



}
